Thought this would be easy!!!!

In RC0 MDS deployment offers a basic wizard and now the MDSModelDeploy tool.

It informs - Model only > use wizard.  Model and Data > MDSDeployment Tool

Also we are informed by the Help preview:

Packages can be deployed to the edition of SQL Server they were created in only. This means that packages created in SQL Server 2008 R2 cannot be deployed to Microsoft SQL Server 2012 Release Candidate 0 (RC 0).

Sure enough, models from Denali fail in the Deployment wizard...

Does this mean there is no way to simply migrate an existing model and data package from Denali, or 2008r2 directly to 2012 (or worse 2012 when it released. To re-do complex models, even with the add-in will be unnecessarily time consuming. Hope I am wrong about the migration process!!!

Please advise.



It should be possible to upgrade Master Data Services databases from CU6 and later to SQL Server 2012 RC0 MDS databases. To do this:

1. install SQL Server 2012 RC0 MDS on a server

2. bring up the MDS Configuration Manager

3. Go into the Databases tab

3. Select the CU6 database. At this point the Configuration Manager should automatically tell you that you need to upgrade the database. I strongly recommend you back up your original database before you do this.

4. Once upgraded, the database is ready to be connected to an SQL Server 2012 RC Master Data Services web application

 

If you aren't on CU6 or need to know how to tell whether you are, go through this blog post: http://sqlblog.com/blogs/mds_team/default.aspx.

Thanks Arunjeet.

That stuff is all a bit of a headache. It would be great if deployment packages had some sort of interoperability between versions. After all they are xml. Now I am having issues with creating a deployment package at all in RC0 (model and data) with MDSModelDeploy.exe as directed by the product.

The documenation says use:

MDSModelDeploy createpackage -model ModelName -version VersionName -service ServiceName -package PackageName -includedata

I try:

MDSModelDeploy createpackage -model Membership -version VERSION_1 -service MDS -package Membership -includedata

but get error:

MDSModelDeploy operation failed. Elapsed time: 00:00:02.2809690
Error:
The CreatePackage command failed because either there is a missing - option or t
he name is not in quotes. All names that contain spaces must be enclosed in quot
ation marks.

It would be very helpful if you could help me here.

 

Hi,

 

Did you try typing the command or was it "copy-pasted" from somewhere? Try manually typing the whole command, we've seen issues with the Windows Command Prompt pasting a slightly different type of dash ("-") when pasting from the web.

 

Amitai Rottem, MSFT

One thing I could think is, your service name might be wrong, you can use 'MDSModelDeploy listservices' command to get the name. Plus, if you only have one MDS service on the server, you don't need to give -service parameter, and it's always a good idea to add quotation mark for model and version name.

yeah its true.. typing manually is worked for me

and also here

-version 'VERSION_1' (Version Name) is case sensitive

Thanks 

Had the same issue, driving me crazy, I was cutting and pasting from notepad, had to type the "-" manually, thanks!